USE [JCYDB]
GO

/****** Object:  Table [dbo].[T_LingDaoDangFengCheck]    Script Date: 06/13/2012 19:17:20 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[T_LingDaoDangFengCheck](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NULL,
	[Gender] [varchar](50) NULL,
	[DOB] [datetime] NULL,
	[Nationality] [varchar](50) NULL,
	[CultureDegree] [varchar](50) NULL,
	[CurrentJobDay] [varchar](50) NULL,
	[CompanyPosition] [varchar](max) NULL,
	[SpouseName] [varchar](50) NULL,
	[SpouseGender] [varchar](50) NULL,
	[SpouseDOB] [datetime] NULL,
	[SpouseNationality] [varchar](50) NULL,
	[SpouseCultureDegree] [varchar](50) NULL,
	[SpouseCurrentJobDay] [varchar](50) NULL,
	[SpouseCompanyPosition] [varchar](max) NULL,
	[Section2] [varchar](max) NULL,
	[HouseAddress] [varchar](255) NULL,
	[HouseSize] [varchar](255) NULL,
	[HouseType] [varchar](255) NULL,
	[OtherHouseAddress] [varchar](255) NULL,
	[OtherHouseSize] [varchar](255) NULL,
	[OtherHouseType] [varchar](255) NULL,
	[BusinessTravelTime] [varchar](255) NULL,
	[BusinessTravelReason] [varchar](255) NULL,
	[BusinessTravelArea] [varchar](255) NULL,
	[BusinessTravelSpenseSource] [varchar](255) NULL,
	[PersonalTravelTime1] [varchar](255) NULL,
	[PersonalTravelReason1] [varchar](255) NULL,
	[PersonalTravelArea1] [varchar](255) NULL,
	[PersonalTravelSpenseSource1] [varchar](255) NULL,
	[PersonalTravelTime2] [varchar](255) NULL,
	[PersonalTravelReason2] [varchar](255) NULL,
	[PersonalTravelArea2] [varchar](255) NULL,
	[PersonalTravelSpenseSource2] [varchar](255) NULL,
	[CarGeneral] [varchar](255) NULL,
	[CarBrand] [varchar](255) NULL,
	[CarDisplacement] [varchar](255) NULL,
	[CarPrice] [varchar](255) NULL,
	[PhoneClaimYear] [varchar](255) NULL,
	[MobilePhoneClaimStandard] [varchar](255) NULL,
	[MobilePhoneActualClaim] [varchar](255) NULL,
	[HomePhoneClaimStandard] [varchar](255) NULL,
	[HomePhoneActualClaim] [varchar](255) NULL,
	[RelatedName1] [varchar](255) NULL,
	[RelationShip1] [varchar](255) NULL,
	[RelatedJobType1] [varchar](255) NULL,
	[RelatedCompany1] [varchar](255) NULL,
	[RelatedPosition1] [varchar](255) NULL,
	[RelatedName2] [varchar](255) NULL,
	[RelationShip2] [varchar](255) NULL,
	[RelatedJobType2] [varchar](255) NULL,
	[RelatedCompany2] [varchar](255) NULL,
	[RelatedPosition2] [varchar](255) NULL,
	[RelatedName3] [varchar](255) NULL,
	[RelationShip3] [varchar](255) NULL,
	[RelatedJobType3] [varchar](255) NULL,
	[RelatedCompany3] [varchar](255) NULL,
	[RelatedPosition3] [varchar](255) NULL,
	[RelatedName4] [varchar](255) NULL,
	[RelationShip4] [varchar](255) NULL,
	[RelatedJobType4] [varchar](255) NULL,
	[RelatedCompany4] [varchar](255) NULL,
	[RelatedPosition4] [varchar](255) NULL,
	[PeculationYear1] [varchar](255) NULL,
	[PeculationTotalTimes1] [varchar](255) NULL,
	[PeculationTotalAmount1] [varchar](255) NULL,
	[CandorTotalAmount1] [varchar](255) NULL,
	[PeculationTotalCount1] [varchar](255) NULL,
	[CandorTotalCount1] [varchar](255) NULL,
	[PeculationYear2] [varchar](255) NULL,
	[PeculationTotalTimes2] [varchar](255) NULL,
	[PeculationTotalAmount2] [varchar](255) NULL,
	[CandorTotalAmount2] [varchar](255) NULL,
	[PeculationTotalCount2] [varchar](255) NULL,
	[CandorTotalCount2] [varchar](255) NULL,
	[PeculationYear3] [varchar](255) NULL,
	[PeculationTotalTimes3] [varchar](255) NULL,
	[PeculationTotalAmount3] [varchar](255) NULL,
	[CandorTotalAmount3] [varchar](255) NULL,
	[PeculationTotalCount3] [varchar](255) NULL,
	[CandorTotalCount3] [varchar](255) NULL,
	[PeculationYear4] [varchar](255) NULL,
	[PeculationTotalTimes4] [varchar](255) NULL,
	[PeculationTotalAmount4] [varchar](255) NULL,
	[CandorTotalAmount4] [varchar](255) NULL,
	[PeculationTotalCount4] [varchar](255) NULL,
	[CandorTotalCount4] [varchar](255) NULL,
	[PeculationYear5] [varchar](255) NULL,
	[PeculationTotalTimes5] [varchar](255) NULL,
	[PeculationTotalAmount5] [varchar](255) NULL,
	[CandorTotalAmount5] [varchar](255) NULL,
	[PeculationTotalCount5] [varchar](255) NULL,
	[CandorTotalCount5] [varchar](255) NULL,
	[Section3Others] [varchar](max) NULL,
	[Section4] [varchar](max) NULL,
	[Section5] [varchar](max) NULL,
	[FillDate] [datetime] NULL,
	[VERSION_NO] [int] NOT NULL,
	[TRANSACTION_ID] [varchar](50) NOT NULL,
	[CREATED_BY] [varchar](50) NOT NULL,
	[CREATED_TIME] [datetime] NOT NULL,
	[LAST_UPDATED_BY] [varchar](50) NULL,
	[LAST_UPDATED_TIME] [datetime] NULL,
	[Reserve1] [varchar](255) NULL,
	[Reserve2] [varchar](255) NULL,
	[Reserve3] [varchar](255) NULL,
	[Reserve4] [varchar](255) NULL,
	[Reserve5] [varchar](255) NULL,
 CONSTRAINT [PK_T_LingDaoDangFengCheck] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


